<pack :locale='1033' class='excel-direct' cleaning='no' compat='no' dataRefreshTime='' ec-data-ts='2124680152470000' ec-logical-query='&lt;logical-query-extended-cache-key&gt;&#10;&lt;relation-xml&gt;&amp;lt;relations&amp;gt;&amp;#10;  &amp;lt;relation connection=&amp;apos;conn1&amp;apos;&amp;gt;&amp;#10;    &amp;lt;relation type=&amp;apos;collection&amp;apos;&amp;gt;&amp;#10;      &amp;lt;relation name=&amp;apos;Orders&amp;apos; table=&amp;apos;[Orders$]&amp;apos; type=&amp;apos;table&amp;apos;&amp;gt;&amp;#10;        &amp;lt;columns gridOrigin=&amp;apos;A1:X10001:no:A1:X10001:0&amp;apos; header=&amp;apos;yes&amp;apos; outcome=&amp;apos;6&amp;apos;&amp;gt;&amp;#10;          &amp;lt;column datatype=&amp;apos;integer&amp;apos; name=&amp;apos;Row ID&amp;apos; ordinal=&amp;apos;0&amp;apos; /&amp;gt;&amp;#10;          &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;Order ID&amp;apos; ordinal=&amp;apos;1&amp;apos; /&amp;gt;&amp;#10;          &amp;lt;column datatype=&amp;apos;date&amp;apos; name=&amp;apos;Order Date&amp;apos; ordinal=&amp;apos;2&amp;apos; /&amp;gt;&amp;#10;          &amp;lt;column datatype=&amp;apos;date&amp;apos; name=&amp;apos;Ship Date&amp;apos; ordinal=&amp;apos;3&amp;apos; /&amp;gt;&amp;#10;          &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;Ship Mode&amp;apos; ordinal=&amp;apos;4&amp;apos; /&amp;gt;&amp;#10;          &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;Customer ID&amp;apos; ordinal=&amp;apos;5&amp;apos; /&amp;gt;&amp;#10;          &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;Customer Name&amp;apos; ordinal=&amp;apos;6&amp;apos; /&amp;gt;&amp;#10;          &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;Segment&amp;apos; ordinal=&amp;apos;7&amp;apos; /&amp;gt;&amp;#10;          &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;City&amp;apos; ordinal=&amp;apos;8&amp;apos; /&amp;gt;&amp;#10;          &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;State&amp;apos; ordinal=&amp;apos;9&amp;apos; /&amp;gt;&amp;#10;          &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;Country&amp;apos; ordinal=&amp;apos;10&amp;apos; /&amp;gt;&amp;#10;          &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;Postal Code&amp;apos; ordinal=&amp;apos;11&amp;apos; /&amp;gt;&amp;#10;          &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;Market&amp;apos; ordinal=&amp;apos;12&amp;apos; /&amp;gt;&amp;#10;          &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;Region&amp;apos; ordinal=&amp;apos;13&amp;apos; /&amp;gt;&amp;#10;          &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;Product ID&amp;apos; ordinal=&amp;apos;14&amp;apos; /&amp;gt;&amp;#10;          &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;Category&amp;apos; ordinal=&amp;apos;15&amp;apos; /&amp;gt;&amp;#10;          &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;Sub-Category&amp;apos; ordinal=&amp;apos;16&amp;apos; /&amp;gt;&amp;#10;          &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;Product Name&amp;apos; ordinal=&amp;apos;17&amp;apos; /&amp;gt;&amp;#10;          &amp;lt;column datatype=&amp;apos;real&amp;apos; name=&amp;apos;Sales&amp;apos; ordinal=&amp;apos;18&amp;apos; /&amp;gt;&amp;#10;          &amp;lt;column datatype=&amp;apos;integer&amp;apos; name=&amp;apos;Quantity&amp;apos; ordinal=&amp;apos;19&amp;apos; /&amp;gt;&amp;#10;          &amp;lt;column datatype=&amp;apos;real&amp;apos; name=&amp;apos;%Discount&amp;apos; ordinal=&amp;apos;20&amp;apos; /&amp;gt;&amp;#10;          &amp;lt;column datatype=&amp;apos;real&amp;apos; name=&amp;apos;Profit&amp;apos; ordinal=&amp;apos;21&amp;apos; /&amp;gt;&amp;#10;          &amp;lt;column datatype=&amp;apos;real&amp;apos; name=&amp;apos;Shipping Cost&amp;apos; ordinal=&amp;apos;22&amp;apos; /&amp;gt;&amp;#10;          &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;Order Priority&amp;apos; ordinal=&amp;apos;23&amp;apos; /&amp;gt;&amp;#10;        &amp;lt;/columns&amp;gt;&amp;#10;      &amp;lt;/relation&amp;gt;&amp;#10;      &amp;lt;relation name=&amp;apos;Manager&amp;apos; table=&amp;apos;[Manager$]&amp;apos; type=&amp;apos;table&amp;apos;&amp;gt;&amp;#10;        &amp;lt;columns gridOrigin=&amp;apos;A1:B14:no:A1:B14:0&amp;apos; header=&amp;apos;yes&amp;apos; outcome=&amp;apos;2&amp;apos;&amp;gt;&amp;#10;          &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;Person&amp;apos; ordinal=&amp;apos;0&amp;apos; /&amp;gt;&amp;#10;          &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;Region&amp;apos; ordinal=&amp;apos;1&amp;apos; /&amp;gt;&amp;#10;        &amp;lt;/columns&amp;gt;&amp;#10;      &amp;lt;/relation&amp;gt;&amp;#10;      &amp;lt;relation name=&amp;apos;Returns&amp;apos; table=&amp;apos;[Returns$]&amp;apos; type=&amp;apos;table&amp;apos;&amp;gt;&amp;#10;        &amp;lt;columns gridOrigin=&amp;apos;A1:C1174:no:A1:C1174:0&amp;apos; header=&amp;apos;yes&amp;apos; outcome=&amp;apos;2&amp;apos;&amp;gt;&amp;#10;          &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;Returned&amp;apos; ordinal=&amp;apos;0&amp;apos; /&amp;gt;&amp;#10;          &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;Order ID&amp;apos; ordinal=&amp;apos;1&amp;apos; /&amp;gt;&amp;#10;          &amp;lt;column datatype=&amp;apos;string&amp;apos; name=&amp;apos;Market&amp;apos; ordinal=&amp;apos;2&amp;apos; /&amp;gt;&amp;#10;        &amp;lt;/columns&amp;gt;&amp;#10;      &amp;lt;/relation&amp;gt;&amp;#10;    &amp;lt;/relation&amp;gt;&amp;#10;    &amp;lt;is-not-distinct-join-semantics&amp;gt;false&amp;lt;/is-not-distinct-join-semantics&amp;gt;&amp;#10;  &amp;lt;/relation&amp;gt;&amp;#10;&amp;lt;/relations&amp;gt;&amp;#10;&lt;/relation-xml&gt;&#10;&lt;logical-query&gt;&#10;&lt;selects&gt;&#10;&lt;field&gt;[Order Priority]&lt;/field&gt;&#10;&lt;field&gt;[sum:Sales:ok]&lt;/field&gt;&#10;&lt;field&gt;[tmn:Order Date:ok]&lt;/field&gt;&#10;&lt;/selects&gt;&#10;&lt;projectOp class=&apos;logical-operator&apos;&gt;&#10;&lt;expressions&gt;&#10;&lt;binding name=&apos;[Order Priority]&apos;&gt;&#10;&lt;identifierExp class=&apos;logical-expression&apos; identifier=&apos;[Order Priority]&apos; /&gt;&#10;&lt;/binding&gt;&#10;&lt;/expressions&gt;&#10;&lt;aggregateOp class=&apos;logical-operator&apos;&gt;&#10;&lt;measures&gt;&#10;&lt;binding name=&apos;[sum:Sales:ok]&apos;&gt;&#10;&lt;funcallExp class=&apos;logical-expression&apos; function=&apos;SUM&apos; shape=&apos;aggregate&apos;&gt;&#10;&lt;identifierExp class=&apos;logical-expression&apos; identifier=&apos;[Sales]&apos; /&gt;&#10;&lt;/funcallExp&gt;&#10;&lt;/binding&gt;&#10;&lt;/measures&gt;&#10;&lt;groupbys&gt;&#10;&lt;binding name=&apos;[Order Priority]&apos;&gt;&#10;&lt;identifierExp class=&apos;logical-expression&apos; identifier=&apos;[Order Priority]&apos; /&gt;&#10;&lt;/binding&gt;&#10;&lt;binding name=&apos;[tmn:Order Date:ok]&apos;&gt;&#10;&lt;funcallExp class=&apos;logical-expression&apos; function=&apos;DATETRUNC&apos; shape=&apos;scalar&apos;&gt;&#10;&lt;literalExp charset=&apos;0&apos; class=&apos;logical-expression&apos; collation=&apos;LROOT&apos; datatype=&apos;string&apos; value=&apos;&amp;quot;month&amp;quot;&apos; /&gt;&#10;&lt;identifierExp class=&apos;logical-expression&apos; identifier=&apos;[Order Date]&apos; /&gt;&#10;&lt;/funcallExp&gt;&#10;&lt;/binding&gt;&#10;&lt;/groupbys&gt;&#10;&lt;relationOp class=&apos;logical-operator&apos; connection=&apos;conn1&apos; name=&apos;[Orders$]&apos;&gt;&#10;&lt;relation name=&apos;Orders&apos; type=&apos;table&apos;&gt;&#10;&lt;attributes gridOrigin=&apos;A1:X10001:no:A1:X10001:0&apos; header=&apos;yes&apos; outcome=&apos;6&apos; /&gt;&#10;&lt;/relation&gt;&#10;&lt;cols&gt;&#10;&lt;/cols&gt;&#10;&lt;type&gt;&#10;&lt;schema&gt;&#10;&lt;field name=&apos;[%Discount]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Category]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[City]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Country]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Customer ID]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Customer Name]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Market]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Order Date]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Order ID]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Order Priority]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Postal Code]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Product ID]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Product Name]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Profit]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Quantity]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Region]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Row ID]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Sales]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Segment]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Ship Date]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Ship Mode]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Shipping Cost]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[State]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;field name=&apos;[Sub-Category]&apos;&gt;&#10;&lt;type name=&apos;top&apos; /&gt;&#10;&lt;/field&gt;&#10;&lt;/schema&gt;&#10;&lt;/type&gt;&#10;&lt;/relationOp&gt;&#10;&lt;/aggregateOp&gt;&#10;&lt;/projectOp&gt;&#10;&lt;/logical-query&gt;&#10;&lt;/logical-query-extended-cache-key&gt;&#10;' filename='Data/Lecture/Superstore Starter.xlsx' interpretationMode='0' is-single-table-union='yes' server='' validate='no'>
</pack>
